B.TECH - Semester 4 database design Question Paper 2019 (jun)
Practice authentic previous year university questions for better exam preparation.
- What is a foreign key? Give an example.
- (b) Create the following tables with foreign key constraints wherever necessary. DEPOSIT(actno,cname,bname,amount,adate) BRANCH(bname,city) CUSTOMERS(cname,City) BORROW(loanno,cname,bname,amount) Write the SQL query for the following
- Differentiate two-tier and three-tier server architecture.
- List out the various cases where use of null value would be appropriate.
- Write any two data manipulation language commands with example.
- Define Multivalued dependency and fourth normal form.
- How does disk monitoring helps in improving reliability?
- What is partitioned hashing? List out its limitations.
- (a) Explain the components of a database management system.
- (b) A hospital offers rooms for a maximum capacity of 3 patients per room. The rooms are numbered consecutively. Doctors and Patients are registered by their first name, sur name and ID. Doctors have a certain function/special subject in the hospital. Doctors treat patients and note details about ev...
- (a) Use the following database schema. Parts(part_id, name, Color, piece_weight;price) Orders(Order_id,customer, shipping_addr, orderdate,shipping_date) Parts_order(order_id,parts_id,quantity, parts_price) And write the relational algebra notation for the following
- (i) What is the total price of each order? (ii) List the name of all parts whose last letter is d' and are red in color. (iii) How many days does it take to ship the orders? (iv) Give the details of all the parts whose price is less than $\operatorname{Rs} 150$ and their color is neither red nor blu...
- (b) Explain the various data models to organize data in DBMS.
- (a) Explain in detail about functional dependencies and Amstrong's axiom.
- (i) List all customers who are depositors but not borrowers (ii) List all the customers along with their amount who are either borrowers or depositors and living in city nagpur. (iii) List the details of all depositors living in city nagpur. (iv) Give the name and the amount added by 500 of the borr...
- (a) Write the algorithm for finding a minimal cover F for a set of functional dependencies $E$. A set of $F D s$ for the relation $R(A, B, C, D, E, F)$ is $A B->C, C->A, B C->D, A C D->B, B E->C, E C->F A, C F->B D, D->E$. Find a minimum cover for this set of FDs.
- (b) With an example for each explain third Bobabab formance Codd normal form.
- (a) Describe the technique for allowing a hash file to expand and shrink dynamically. What are its advantages and disadvantages?
- (b) Write an algorithm for testing the conflict serializability of a schedule. OR
- (a) Explain the different types of transaction failures. Also brief about catastrophic failure.
- (b) Describe the concurrency control mechanisms based on timestamp ordering. ( $\mathbf{3} \boldsymbol{\times} \mathbf{2 0} \boldsymbol{=} \mathbf{6 0}$ Marks)
- What are the responsibilities of the DBA and the database designer?
- Explain how a One to many relationship in an ER diagram is converted into relation.
- How does two-phase locking protocol ensure serializability? ( $10 \times 4=40$ Marks) P.T.O. PART - B Answer any one question from each Module.
Browse Previous Year Question Papers →